DB2 Parallel Edition

نویسندگان

  • Chaitanya K. Baru
  • Gilles Fecteau
  • Ambuj Goyal
  • Hui-I Hsiao
  • Anant Jhingran
  • Sriram Padmanabhan
  • George P. Copeland
  • Walter G. Wilson
چکیده

The rate of increase in database size and response time requirements has outpaced advancements in processor and mass storage technology. One way to satisfy the increasing demand for processing power and I/O bandwidth in database applications is to have a number of processors, loosely or tightly coupled, serving database requests concurrently. Technologies developed during the last decade have made commercial parallel database systems a reality and these systems have made an inroad into the stronghold of traditionally mainframe based large database applications. This paper describes the parallel database project initiated at IBM Research at Hawthorne and the DB2/AIX-PE product based on it.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Managing a DB2 Parallel Edition Database

In this presentation, the author will describe how to manage a DB2 Parallel Edition (I%) Database. DB2 I% belongs to the IBM, family of open DB2 client/.server database products including Dl32/6000, DB2/2, DB2 for fIP-IJX, and DB2 for the Solaris Operating Environment. DB2 PE employs a shared nothing architecture in which the database system consists of a set of independent logical drtabase nod...

متن کامل

Extracting Large Data Sets using DB2 Parallel Edition

Commercial parallel database systems such as DB2 Parallel Edition (DB2 PE) [l, 21 are delivering the ability to execute complex queries on very large databases. However, the serial application interface to these database systems can become a bottleneck for a growing list of applications such as mailing list generation and data propagation from a warehouse to smaller data marts. In this abstract...

متن کامل

Performance of DB2 Enterprise-Extended Edition on NT with Virtual Interface Architecture

DB2 Universal Database Enterprise-Extended Edition (DB2 UDB EEE) is a parallel relational database management system using a sharednothing architecture. DB2 UDB EEE uses multiple nodes connected by an interconnect and partitions data across these nodes. The communication protocol used between nodes of DB2 UDB EEE has historically been Transmission Control Protocol (TCP) / Internet Protocol (IP)...

متن کامل

Born To Be Parallel: Why Parallel Origins Give Teradata an Enduring Performance Edge

This paper describes query optimization and processing in DB2 Parallel Edition – a full function, par-allel, scalable database system from IBM. We give a brief overview of the components, and delve deeperinto query optimization. In particular, we discuss the use of data partitioning as a property of operatorsand issues related to “SQL Completeness”, wherein some SQL constructs like ...

متن کامل

DB2 Query Parallelism: Staging and Implementation

Intraquery parallelism has been recognized as a key requirement for DB2 major customers to allow data intensive queries with acceptable response time. DB2 delivers intraquery parallelism in three stages since DB2 Version 3 Release 1 in 1993. DB2 intraquery parallelism requires extensions on many DB2 components, such as optimizer, query executor, buffer manager, . ..etc. We briefly discuss the m...

متن کامل

ذخیره در منابع من

ذخیره در منابع من قبلا به منابع من ذحیره شده

{@ msg_add @}


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • IBM Systems Journal

دوره 34  شماره 

صفحات  -

تاریخ انتشار 1995